package com.ilink.groundservice.mapper.innovationPlaza;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ilink.groundservice.entity.PO.innovationPlaza.ProjectUser;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ProjectUserMapper extends BaseMapper<ProjectUser> {
    @Select("SELECT pu.user_type, pu.user_name, pu.user_college, pu.user_introduction, pu.user_grade, pu.user_major, pu.user_image " +
            "FROM project_user pu " +
            "WHERE pu.project_id = #{projectId}")
    List<ProjectUser> getProjectMembersByProjectId(@Param("projectId") Long projectId);
}
